<%@ page language="java"  pageEncoding="utf-8"%>
<%@ page import="java.util.Vector,com.ejoysoft.wlanyz.business.Ap,com.ejoysoft.wlanyz.business.Paper,
com.ejoysoft.common.Constants,com.ejoysoft.common.exception.NoRightException" %>
<%@ include file="../include/jsp/head.jsp"%>
<%
if(!globa.userSession.hasRight("20005"))
      throw new NoRightException("用户不具备操作该功能模块的权限，请与系统管理员联系！");
%>

<%
    //初始化
    Paper paper = new Paper (globa);
    Ap  ap0=null;
    Ap obj=new Ap(globa);
    //查询条件
    String  HOTSPOT=ParamUtil.getString(request,"HOTSPOT","").trim();
    String  strApName=ParamUtil.getString(request,"strApName","").trim();
    String  strApIp=ParamUtil.getString(request,"strApIp","").trim();	
	String tWhere=" WHERE 1=1";
    if(!HOTSPOT.equals("")){
     tWhere += " and a.HOTSPOT LIKE '%"+ HOTSPOT +"%'";
    }
    if(!strApName.equals("")){
     tWhere += " and a.DEVICE_NAME LIKE '%"+ strApName +"%'";     
    }
    if(!strApIp.equals("")){
     tWhere += " and a.IP_ADDR LIKE '%"+ strApIp +"%'";
    }
	 tWhere += " "; 
	//记录总数
	int intAllCount=obj.getCount(tWhere);	
	//当前页
    int intCurPage=globa.getIntCurPage();
	//每页记录数
	String strPageSize = ParamUtil.getString(request,"strPageSize","10");
    int intPageSize;
    if(strPageSize.equals("所有"))intPageSize = intAllCount;
      else  intPageSize = Integer.parseInt(strPageSize);
	//共有页数
 	int intPageCount=(intAllCount-1)/intPageSize+1;
	// 循环显示一页内的记录 开始序号
	int intStartNum=(intCurPage-1)*intPageSize+1;
	//结束序号
	int intEndNum=intCurPage*intPageSize;   
	//获取到当前页面的记录集
	Vector<Ap> vctObj=obj.list(tWhere,intStartNum,intPageSize);
	//获取当前页的记录条数
	int intVct=(vctObj!=null&&vctObj.size()>0?vctObj.size():0);
%>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../css/main.css" rel="stylesheet" type="text/css" />
<style>
<!--
body {
	background-color: #f2f8ff;
}
.sel1{ width:160px;}
.STYLE1 {color: #FF0000}
.s6 a:link{ line-height:25px;height:25px; color:#333333}
.s6 a:hover{ line-height:25px;height:25px; color:#333333}
--> 
</style>
 <link href="../jquerytable/Styles/Site.css" rel="stylesheet" type="text/css" />
    <script src="../jquerytable/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <script src="../jquerytable/Scripts/JQueryPlugin/TableSort.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $("#tb").sorttable({
                ascImgUrl: "../jquerytable/Images/bullet_arrow_up.png",
                descImgUrl: "../jquerytable/Images/bullet_arrow_down.png",
                ascImgSize: "8px",
                descImgSize: "8px",
                sorttingMsg: "数据加载中...",
                sorttingMsgColor: "#FF6600",
                 maskOpacity: "0.6",
                 maskColor:"#D2F1FF",
                onSorted: function (cell) {
                  //  alert(cell.index() + " -- " + cell.text());
                }
            });
        });
    </script>
<script type="text/javascript">

 function showAc(){ 
  frm.action="ap_list.jsp";
  frm.<%=com.ejoysoft.common.Constants.PAGE_SIZE_INDEX%>.value = "1";
  frm.submit();
 }
 
 function export_sbm(page){ 
  frm.action="ap_export.jsp";
  document.getElementById("strCurPage").value = "<%=intCurPage%>";
  document.getElementById("exportContent").value = page;
  frm.submit();
 }
  function alertnull()
 {
 alert("该二级热点还没有图纸！！！");
 }
 
 
</script>
</head>


<body>
<form name="frm" method="post" action="ap_list.jsp">
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30"><img src="../images/ri_list.jpg" width="14" height="14" align="absbottom" />&nbsp;您现在所在的位置：<font color="#0e7cc9">专项优化</font> &gt; AP无线查询</td>
  </tr>
</table>
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  
  <tr>
    <td height="45" valign="middle" bgcolor="e1eef7">
      <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td width="31%" height="40" >热点(<span class="STYLE1">*</span>)
         <input id="HOTSPOT" name="HOTSPOT" type="text" style="width:70%" value="<%=HOTSPOT %>"  class="sell"/>
        </td>
        <td width="31%" >AP(<span class="STYLE1">*</span>)
          <input id="strApName" name="strApName" type="text" style="width:70% " value="<%=strApName %>"/>
        </td>
        <td width="31%" >IP地址(<span class="STYLE1">*</span>)
          <input id="strApIp" name="strApIp" type="text" style="width:70%" value="<%=strApIp %>"/>
        </td>
        <td><img src="../images/search.jpg" width="58" height="28" onclick="showAc()" style="cursor:hand"/></td>
        </tr>
      </table></td>
  </tr>
</table>
<br/>
<table id="tb" width="97%" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr role="head">
    <td sort="true" width="6%" class="listtit">城市</td>
    <td  sort="true" width="6%" class="listtit">区县</td>
    <td sort="true" width="15%" class="listtit">热点</td>
    <td sort="true" width="25%" class="listtit">AP名称</td>
    <td sort="true" width="6%" class="listtit">信道质量</td>
    <td sort="true" width="6%" class="listtit">信号强度</td>
    <td sort="true" width="6%" class="listtit">信噪比</td>
    <td width="8%" class="listtit">拓扑定位</td>
  </tr>
        <%
            for (int i = 0;i < vctObj.size(); i++) {
            	Ap obj1 = vctObj.get(i);    
            	int papernum = paper.getPaperNum(" where acname ='"+obj1.getstrId()+"'"); 
         %>
  <tr>
    <td align="center" class="listd1"><%=obj1.getApCity() %></td>
    <td align="center" class="listd1"><%=obj1.getApCounty() %></td>
    <td align="center" class="listd1"><%=obj1.getHotSpot() %></td>
    <td align="center" class="listd1"><%=obj1.getApName() %></td>
    <td align="center" class="listd1"><%=obj1.getApQuality() %></td>
    <td align="center" class="listd1"><%=obj1.getApRssi() %></td>
    <td align="center" class="listd1"><%=obj1.getApRsn() %></td>
     <td align="center" class="listdrd"> <a class="a1"href="#" onclick="<%if( papernum==0){ %>alertnull()<%} %><%else{ %>window.parent.leftFrame.location='../left.jsp?actionFlag=拓扑呈现&rootFlag=日常管理';window.parent.mainFrame.location='../topology/topology_show.jsp?classTwoACName=<%=obj1.getstrId() %>';<%} %>"><img src="../images/map_blue.png" height="20" border="0" /></a>
       </td>
  </tr>
         <%
          }//for 
         %> 
</table>

<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="61%" height="50" valign="bottom"><!--<img src="../images/pldel.jpg" width="83" height="27" align="absmiddle" />--> &nbsp;&nbsp;页面记录数
      <select name="strPageSize" id="strPageSize" style="width:52px;" onchange="showAc()">
		<% 
		 String sltOpt[] = {"10","20","30","50","70","100","所有"};
		 for(int i=0; i < sltOpt.length;i++){
		 	String selected = "";
		    if(sltOpt[i].equals(strPageSize))
		      selected="selected='selected'";
		 %>
		 <option value="<%=sltOpt[i] %>" <%=selected %>><%=sltOpt[i] %></option>
   		<%
   		 }
   		 %>
   		 </select>
      <img src="../images/dc.jpg" width="92" height="27" align="absmiddle" onclick="export_sbm('currentPage')" style="cursor:hand"/> <img src="../images/dcall.jpg" width="82" height="27" align="absmiddle" onclick="export_sbm('allPage')" style="cursor:hand"/></td>
      <td>  <input id="exportFlag" name="exportFlag" type="hidden" value="exportResult"/>
       		 <input id="strCurPage" name="strCurPage" type="hidden" value=""/>
			<input id="exportContent" name="exportContent" type="hidden" value=""/></td>
    
      <td width="39%" align="right" valign="bottom"><!--<table width="310" border="0" cellspacing="0" cellpadding="0">
       <tr>
        <td width="40"><img src="../images/up.jpg" width="40" height="30" /></td>
        <td width="221" align="center" background="../images/page_bg.jpg" class="page"><a href="#">1</a>&nbsp; <a href="#">2</a>&nbsp; <a href="#">3</a>&nbsp; <a href="#"><span class="sel">4</span></a>&nbsp; <a href="#">5</a> &nbsp;<a href="#">6</a> &nbsp;<a href="#">7</a>&nbsp; <a href="#">8 </a>&nbsp;<a href="#">9</a>&nbsp;...&nbsp;<a href="#">13</a> </td>
        <td width="39"><img src="../images/down.jpg" width="39" height="30" /></td>
       </tr>
    </table>
  -->
  <!-- 翻页开始 -->  
     	<%@ include file="../include/jsp/cpage.jsp"%>
       	<!-- 翻页结束 --> </td>
  </tr>
</table>
</form>
</body>
</html>
<%@ include file="../include/jsp/footer.jsp"%>